package top.majuan.study.javawebjdbc.dao;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;

public class DBHelper {
   // 数据库链接url
   public static final String URL = "jdbc:mysql://teach_mysql.huhuiyu.top:31000/db_majuan?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8&useSSL=false&allowPublicKeyRetrieval=true&serverTimezone=Asia/Shanghai";
   //数据用户名
   public static final String USER = "db_majuan";
   // 数据库密码
   public static final String PASSWORD = "20050315majuan";
   //数据库驱动类名称
   public static final String DRIVER = "com.mysql.cj.jdbc.Driver";

   static {
      // 加载驱动程序
       try {
           Class.forName(DRIVER);
       } catch (ClassNotFoundException e) {
           throw new RuntimeException(e);
       }
   }

   // 获取数据库链接
   public static Connection getConnection() {
       try {
           return DriverManager.getConnection(URL, USER, PASSWORD);
       } catch (SQLException e) {
           throw new RuntimeException(e);
       }
   }



}
